USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[LogFilesInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.LogFilesInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	LogFiles Table Insert
-- =============================================
CREATE PROCEDURE LogFilesInsert

           @LogId int,
           @LogName varchar(100),
           @LogFileName varchar(100),
           @LogLocation varchar(100),
           @DateTime datetime,
           @MapId int,
           @RedFinalScore int,
           @BlueFinalScore int,
           @MatchStartTime datetime,
           @MatchEndTime datetime,
           @TotalMatchLength int,
           @LeagueId int
	

AS
BEGIN

INSERT INTO [LogFiles]
           ([LogId]
           ,[LogName]
           ,[LogFileName]
           ,[LogLocation]
           ,[DateTime]
           ,[MapId]
           ,[RedFinalScore]
           ,[BlueFinalScore]
           ,[MatchStartTime]
           ,[MatchEndTime]
           ,[TotalMatchLength]
           ,[LeagueId] )
     VALUES
           (@LogId,
           @LogName,
           @LogFileName, 
           @LogLocation,
           @DateTime,
           @MapId,
           @RedFinalScore,
           @BlueFinalScore,
           @MatchStartTime,
           @MatchEndTime, 
           @TotalMatchLength,
           @LeagueId )
END
GO
